{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Informal & Formal Bargaining (BAA Reforms)\JOP Replication File Materials\JOP Dataverse Replication Files\Output\execbudinfluence.10-18-2020.FIGURE 1.SPENDING BIAS DIFFERENTIALS.03-10-2021.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}10 Mar 2021, 17:00:31
{txt}
{com}. 
. 
. 
. 
.  * OPEN "EXECUTIVE BUDGETARY INFLUENCE" DATABASE WITH PAIR OF NEWLY CREATED VARIABLES TO EVALUATE SPENSING BIAS DIFFERENTIALS *
.  
. use "C:\Users\gk57526\Dropbox\Informal & Formal Bargaining (BAA Reforms)\JOP Replication File Materials\JOP Dataverse Replication Files\Data\execbudinfluence.08-26-2020.REPORTED MODELS.REV.V2.10-17-2020.dta", replace
{txt}
{com}. 
.  
. 
. *** DECLARE DATABASE AS A PANEL (AGENCY ID * FISCAL YEAR): 
. 
. xtset agenid fyear, yearly
{res}{txt}{col 8}panel variable:  {res}agenid (unbalanced)
{txt}{col 9}time variable:  {res}{col 25}fyear, 1894 to 1940
{txt}{col 17}delta:  {res}1 year
{txt}
{com}. 
. *
. *
. *
. 
. 
. *****************************************************************************************************************************************************************************************
. **********************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. 
. 
. 
. quietly movestay congbudchangereg2  l1congbudchangereg2  execbudchangereg2 ebcreg2baa  bureauofbudget lnagencyage unifiedpartygovt  presadminyear ///
> if agenid!=15, cluster(agenid)  select(regimereg = executiveagency)
{txt}
{com}. 
. 
. 
. *** REGULAR DISCRETIONARY BUDGETS [EXCLUDING EXTRAMURAL FUNDS] ***
. 
. *** PRE-BAA REFORM ERA: AUSTERE EXECUTIVE BUDGET PROPOSALS [E <= A] ***
. 
. sum diffexeccongbudreg if e(sample) & bureauofbudget==0 & regimereg==1, detail

               {txt}realexecestreg - realcongappreg
{hline 61}
      Percentiles      Smallest
 1%    {res}-1.96e+08      -1.96e+08
{txt} 5%    {res}-8.47e+07      -1.02e+08
{txt}10%    {res}-3.76e+07      -9.08e+07       {txt}Obs         {res}         77
{txt}25%    {res}-1.63e+07      -8.47e+07       {txt}Sum of Wgt. {res}         77

{txt}50%    {res} -3617820                      {txt}Mean          {res}-1.49e+07
                        {txt}Largest       Std. Dev.     {res} 2.99e+07
{txt}75%    {res}  -911328              0
{txt}90%    {res}   -59508              0       {txt}Variance      {res} 8.92e+14
{txt}95%    {res}        0              0       {txt}Skewness      {res}-3.836984
{txt}99%    {res}        0              0       {txt}Kurtosis      {res} 20.54712
{txt}
{com}. 
. display r(sum)
{res}-1.148e+09
{txt}
{com}. 
. 
. 
. *** PRE-BAA REFORM ERA: PROFLIGATE EXECUTIVE BUDGET PROPOSALS [E > A] ***
. 
. sum diffexeccongbudreg if e(sample) & bureauofbudget==0 & regimereg==0, detail

               {txt}realexecestreg - realcongappreg
{hline 61}
      Percentiles      Smallest
 1%    {res} 10854.87        921.625
{txt} 5%    {res}    86934       10854.87
{txt}10%    {res}   199393          25908       {txt}Obs         {res}        163
{txt}25%    {res}   515478        26132.4       {txt}Sum of Wgt. {res}        163

{txt}50%    {res}  1694345                      {txt}Mean          {res} 1.58e+07
                        {txt}Largest       Std. Dev.     {res} 7.23e+07
{txt}75%    {res}  9128960       1.19e+08
{txt}90%    {res} 2.11e+07       1.97e+08       {txt}Variance      {res} 5.23e+15
{txt}95%    {res} 2.96e+07       4.43e+08       {txt}Skewness      {res} 8.698177
{txt}99%    {res} 4.43e+08       7.79e+08       {txt}Kurtosis      {res} 85.13756
{txt}
{com}. 
. display r(sum)
{res}2.570e+09
{txt}
{com}. 
. display 2.570e+09 / -1.148e+09
{res}-2.238676
{txt}
{com}. 
. 
. 
. ******************************************************************************************************************************************************************************************
. ******************************************************************************************************************************************************************************************
. ******************************************************************************************************************************************************************************************
. 
. 
. *** POST-BAA REFORM ERA: AUSTERE EXECUTIVE BUDGET PROPOSALS [E <= A] ***
. 
. sum diffexeccongbudreg if e(sample) & bureauofbudget==1 & regimereg==1, detail

               {txt}realexecestreg - realcongappreg
{hline 61}
      Percentiles      Smallest
 1%    {res}-1.59e+08      -4.87e+08
{txt} 5%    {res}-3.55e+07      -2.55e+08
{txt}10%    {res}-1.40e+07      -1.59e+08       {txt}Obs         {res}        276
{txt}25%    {res} -1362284      -1.55e+08       {txt}Sum of Wgt. {res}        276

{txt}50%    {res}-80123.19                      {txt}Mean          {res} -7872891
                        {txt}Largest       Std. Dev.     {res} 3.73e+07
{txt}75%    {res}        0              0
{txt}90%    {res}        0              0       {txt}Variance      {res} 1.39e+15
{txt}95%    {res}        0              0       {txt}Skewness      {res}-9.440885
{txt}99%    {res}        0              0       {txt}Kurtosis      {res} 109.1925
{txt}
{com}. 
. display r(sum)
{res}-2.173e+09
{txt}
{com}. 
. 
. 
. *** POST-BAA REFORM ERA: PROFLIGATE EXECUTIVE BUDGET PROPOSALS [E > A] ***
. 
. sum diffexeccongbudreg if e(sample) & bureauofbudget==1 & regimereg==0, detail

               {txt}realexecestreg - realcongappreg
{hline 61}
      Percentiles      Smallest
 1%    {res} 1139.303        446.248
{txt} 5%    {res}   2596.5       1139.303
{txt}10%    {res}     7874       1622.688       {txt}Obs         {res}        159
{txt}25%    {res} 44770.63       1663.375       {txt}Sum of Wgt. {res}        159

{txt}50%    {res}   367928                      {txt}Mean          {res} 1.93e+07
                        {txt}Largest       Std. Dev.     {res} 9.59e+07
{txt}75%    {res}  4844872       2.07e+08
{txt}90%    {res} 2.58e+07       2.11e+08       {txt}Variance      {res} 9.20e+15
{txt}95%    {res} 5.27e+07       4.79e+08       {txt}Skewness      {res} 9.045787
{txt}99%    {res} 4.79e+08       1.07e+09       {txt}Kurtosis      {res} 93.61909
{txt}
{com}. 
. display r(sum)
{res}3.069e+09
{txt}
{com}. 
. display 3.069e+09 / -2.173e+09
{res}-1.4123332
{txt}
{com}. 
. 
. 
.  *** COMPUTE FACTOR RATIO CHANGE FROM PRE-BAA REFORM TO POST-BAA REFORM ERA ***
. 
. display (-1.4123332 / -2.238676)*100 - 100
{res}-36.912121
{txt}
{com}. 
. 
. 
. *****************************************************************************************************************************************************************************************
. *****************************************************************************************************************************************************************************************
. *****************************************************************************************************************************************************************************************
. *****************************************************************************************************************************************************************************************
. *****************************************************************************************************************************************************************************************
. ****************************************************************************************************************************************************************************************
. 
. 
. 
. *** NOW FOR TOTAL DISCRETIONARY BUDGETS 9INCLUDING EXTRAMURAL FUNDS] ***
. 
. 
. 
. 
. *** PRE-BAA REFORM ERA: AUSTERE EXECUTIVE BUDGET PROPOSALS [E <= A] ***
. 
. sum diffexeccongbudtot if e(sample) & bureauofbudget==0 & regimereg==1, detail

               {txt}realexecesttot - realcongapptot
{hline 61}
      Percentiles      Smallest
 1%    {res}-9.42e+08      -9.42e+08
{txt} 5%    {res}-1.02e+08      -5.05e+08
{txt}10%    {res}-3.79e+07      -1.96e+08       {txt}Obs         {res}         77
{txt}25%    {res} -9389440      -1.02e+08       {txt}Sum of Wgt. {res}         77

{txt}50%    {res} -1277150                      {txt}Mean          {res}-2.83e+07
                        {txt}Largest       Std. Dev.     {res} 1.25e+08
{txt}75%    {res}   -30500         188095
{txt}90%    {res} 90229.25       204618.5       {txt}Variance      {res} 1.56e+16
{txt}95%    {res}   188095       7.87e+07       {txt}Skewness      {res}-5.908053
{txt}99%    {res} 1.39e+08       1.39e+08       {txt}Kurtosis      {res} 41.05379
{txt}
{com}. 
. display r(sum)
{res}-2.179e+09
{txt}
{com}. 
. 
. 
.  *** PRE-BAA REFORM ERA: PROFLIGATE EXECUTIVE BUDGET PROPOSALS [E > A] ***
. 
. sum diffexeccongbudtot if e(sample) & bureauofbudget==0 & regimereg==0, detail

               {txt}realexecesttot - realcongapptot
{hline 61}
      Percentiles      Smallest
 1%    {res}  921.625          -1947
{txt} 5%    {res} 53516.82        921.625
{txt}10%    {res}   170046       10854.87       {txt}Obs         {res}        163
{txt}25%    {res}   423708          25908       {txt}Sum of Wgt. {res}        163

{txt}50%    {res}  1347516                      {txt}Mean          {res} 1.68e+07
                        {txt}Largest       Std. Dev.     {res} 7.84e+07
{txt}75%    {res}  8675728       1.19e+08
{txt}90%    {res} 1.94e+07       4.42e+08       {txt}Variance      {res} 6.15e+15
{txt}95%    {res} 2.96e+07       4.43e+08       {txt}Skewness      {res}  7.69059
{txt}99%    {res} 4.43e+08       7.79e+08       {txt}Kurtosis      {res} 66.30779
{txt}
{com}. 
. display r(sum)
{res}2.746e+09
{txt}
{com}. 
. 
. display 2.746e+09 / -2.179e+09
{res}-1.2602111
{txt}
{com}. 
. 
. 
. 
. *** POST-BAA REFORM ERA: AUSTERE EXECUTIVE BUDGET PROPOSALS [E <= A] ***
. 
. sum diffexeccongbudtot if e(sample) & bureauofbudget==1 & regimereg==1, detail

               {txt}realexecesttot - realcongapptot
{hline 61}
      Percentiles      Smallest
 1%    {res}-6.68e+08      -1.19e+09
{txt} 5%    {res}-4.39e+07      -6.76e+08
{txt}10%    {res}-1.93e+07      -6.68e+08       {txt}Obs         {res}        276
{txt}25%    {res} -1405529      -4.87e+08       {txt}Sum of Wgt. {res}        276

{txt}50%    {res}-84452.19                      {txt}Mean          {res}-1.39e+07
                        {txt}Largest       Std. Dev.     {res} 1.21e+08
{txt}75%    {res}        0              0
{txt}90%    {res}        0              0       {txt}Variance      {res} 1.46e+16
{txt}95%    {res}        0       1.40e+08       {txt}Skewness      {res} -2.06218
{txt}99%    {res}        0       1.09e+09       {txt}Kurtosis      {res}  65.7119
{txt}
{com}. 
. display r(sum)
{res}-3.849e+09
{txt}
{com}. 
. 
. 
. *** POST-BAA REFORM ERA: PROFLIGATE EXECUTIVE BUDGET PROPOSALS [E > A] ***
. 
. sum diffexeccongbudtot if e(sample) & bureauofbudget==1 & regimereg==0, detail

               {txt}realexecesttot - realcongapptot
{hline 61}
      Percentiles      Smallest
 1%    {res}-4.85e+08      -8.26e+08
{txt} 5%    {res} 2277.906      -4.85e+08
{txt}10%    {res}     7191        446.248       {txt}Obs         {res}        159
{txt}25%    {res} 40770.75       1139.303       {txt}Sum of Wgt. {res}        159

{txt}50%    {res} 349320.9                      {txt}Mean          {res} 1.06e+07
                        {txt}Largest       Std. Dev.     {res} 1.25e+08
{txt}75%    {res}  4492160       2.11e+08
{txt}90%    {res} 2.56e+07       3.22e+08       {txt}Variance      {res} 1.55e+16
{txt}95%    {res} 4.18e+07       4.79e+08       {txt}Skewness      {res} 2.000191
{txt}99%    {res} 4.79e+08       1.07e+09       {txt}Kurtosis      {res} 48.82694
{txt}
{com}. 
. display r(sum)
{res}1.684e+09
{txt}
{com}. 
. 
. display 1.684e+09 / -3.849e+09
{res}-.43751624
{txt}
{com}. 
. 
. 
. display (-.43751624 / -1.2602111)*100 - 100
{res}-65.282305
{txt}
{com}. 
. 
. 
. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\Informal & Formal Bargaining (BAA Reforms)\JOP Replication File Materials\JOP Dataverse Replication Files\Output\execbudinfluence.10-18-2020.FIGURE 1.SPENDING BIAS DIFFERENTIALS.03-10-2021.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}10 Mar 2021, 17:00:31
{txt}{.-}
{smcl}
{txt}{sf}{ul off}